4/34

# Changes in This Release for Oracle Big Data Connectors User's Guide

This preface contains:

- Changes in Oracle Big Data Connectors Release 3 (3.1)

- Changes in Oracle Big Data Connectors Release 3 (3.0)

## Changes in Oracle Big Data Connectors Release 3 (3.1)

The following are changes in Oracle Big Data Connectors User's Guide for Oracle Big Data Connectors Release 3 (3.1).

This table shows the software versions installed with Oracle Big Data Connectors 3.1:

Connector | Version
--- | ---
Oracle SQL Connector for HDFS | 3.1
Oracle Loader for Hadoop | 3.1
Oracle Data Integrator Application Adapter for Hadoop | 11.1.7.0
Oracle XQuery for Hadoop | 4.0
Oracle R Advanced Analytics for Hadoop | 2.4

### New Features

Oracle Big Data Connectors support Cloudera's Distribution including Apache Hadoop version 5 (CDH5) and Yet Another Resource Negotiator (YARN). MapReduce programs might require recompiling under YARN.

- Oracle SQL Connector for Hadoop Distributed File System

- Oracle Loader for Hadoop

- Oracle XQuery for Hadoop

  - Support for `oxh:println` and `oxh:println-xml` functions

  - Support for libraries located on HDFS through `-sharelib` command line parameter

- XML Extension for Hive, support for a new table parameter `oxh-default-namespace` added

  Note:

  You no longer require Oracle Big Data Appliance to use XML Extension for Hive with Oracle Big Data Connectors.

### Deprecated Features

The following features are deprecated in this release, and may be desupported in a future release:

- Oracle Loader for Hadoop

  - Support for Cloudera's Distribution including Apache Hadoop version 3 (CDH3)

  - Support for Apache Hadoop 1

## Changes in Oracle Big Data Connectors Release 3 (3.0)

The following are changes in Oracle Big Data Connectors User's Guide for Oracle Big Data Connectors Release 3 (3.0).

This table shows the software versions installed with Oracle Big Data Connectors 3.0:

Connector | Version
--- | ---
Oracle SQL Connector for HDFS | 3.0.0
Oracle Loader for Hadoop | 3.0.0
Oracle Data Integrator Application Adapter for Hadoop | 11.1.7.0
Oracle XQuery for Hadoop | 3.0.0
Oracle R Advanced Analytics for Hadoop | 2.4

### New Features

Oracle Big Data Connectors support Cloudera's Distribution including Apache Hadoop version 5 (CDH5) and Yet Another Resource Negotiator (YARN). MapReduce programs might require recompiling under YARN.

- Oracle SQL Connector for Hadoop Distributed File System

  - Supports partitioned Hive tables. You can query a partition or a range of partitions, and load only what you need for further analysis into tables in Oracle Database.

    See "Creating External Tables from Hive Tables".

  - Provides two new commands, `-drop` and `-describe`, to the command-line tool. These commands facilitate administering the external tables and location files generated by Oracle SQL Connector for HDFS.

    See "Using the ExternalTable Command-Line Tool".

  - Supports new data types introduced in Hive versions 0.12.0 and 0.13.0, and included in CDH5: `char`, `date`, `decimal(``p,s``)`, and `varchar`.

    See "Data Type Mappings".

- Oracle Loader for Hadoop

  - Supports partitioned Hive tables, so that you can load one or more partitions into Oracle Database as an alternative to the entire table.

  See "Hive Table Input Format".

- Oracle XQuery for Hadoop

  - Enables you to run Oracle XQuery for Hadoop queries from Apache Oozie. See "Running Queries from Apache Oozie".

  - Provides an Apache Solr adapter, which you can use to query Cloudera Search.

    See "Solr Adapter".

### Deprecated Features

The following features are deprecated in this release, and may be desupported in a future release:

- Oracle SQL Connector for HDFS

  The `-getDDL` and `-listLocations` commands are superseded by `-describe`.

  See "ExternalTable Command-Line Tool Syntax".

### Desupported Features

The following features are no longer supported by Oracle.

- Oracle SQL Connector for HDFS

  The `-publish` command is not supported for Hive